In [1]:
In [2]:
Out[2]:
State/UTs Total Cases Active Discharged Deaths Active Ratio Discharge Ratio Death Ratio Population
0 Andaman and Nicobar 7680 5 7546 129 0.07 98.26 1.68 399001
1 Andhra Pradesh 2072446 2158 2055856 14432 0.10 99.20 0.70 91702478
2 Arunachal Pradesh 55269 37 54952 280 0.07 99.43 0.51 1711947
3 Assam 616435 2720 607624 6091 0.44 98.57 0.99 35998752
4 Bihar 726212 39 716510 9663 0.01 98.66 1.33 128500364
In [3]:
Out[3]:
(36, 9)
In [4]:
Out[4]:
Index(['State/UTs', 'Total Cases', 'Active', 'Discharged', 'Deaths',
       'Active Ratio', 'Discharge Ratio', 'Death Ratio', 'Population'],
      dtype='object')
In [5]:
<class 'pandas.core.frame.DataFrame'>
RangeIndex: 36 entries, 0 to 35
Data columns (total 9 columns):
 #   Column           Non-Null Count  Dtype  
---  ------           --------------  -----  
 0   State/UTs        36 non-null     object 
 1   Total Cases      36 non-null     int64  
 2   Active           36 non-null     int64  
 3   Discharged       36 non-null     int64  
 4   Deaths           36 non-null     int64  
 5   Active Ratio     36 non-null     float64
 6   Discharge Ratio  36 non-null     float64
 7   Death Ratio      36 non-null     float64
 8   Population       36 non-null     int64  
dtypes: float64(3), int64(5), object(1)
memory usage: 2.7+ KB
In [6]:
Out[6]:
0
In [7]:
Out[7]:
Total Cases Active Discharged Deaths Active Ratio Discharge Ratio Death Ratio Population
count 3.600000e+01 36.000000 3.600000e+01 36.000000 36.000000 36.000000 36.000000 3.600000e+01
mean 9.603479e+05 2935.861111 9.443966e+05 13015.388889 0.318889 98.400556 1.280278 3.971861e+07
std 1.440079e+06 8411.275260 1.411816e+06 24536.093501 0.541536 0.646578 0.560706 5.050913e+07
min 7.680000e+03 1.000000 7.546000e+03 4.000000 0.010000 96.570000 0.040000 6.600100e+04
25% 8.469150e+04 111.250000 8.356425e+04 820.750000 0.037500 97.957500 0.962500 1.695473e+06
50% 4.762030e+05 290.500000 4.651255e+05 5615.500000 0.165000 98.445000 1.315000 2.410088e+07
75% 1.017173e+06 2174.000000 1.004076e+06 13802.750000 0.375000 98.697500 1.597500 6.979986e+07
max 6.633612e+06 49152.000000 6.480799e+06 140908.000000 3.070000 99.950000 2.750000 2.315026e+08
In [8]:
Out[8]:
Total Cases Active Discharged Deaths Active Ratio Discharge Ratio Death Ratio Population
Total Cases 1.000000 0.706727 0.999988 0.910360 -0.016183 -0.063901 0.090619 0.525865
Active 0.706727 1.000000 0.707473 0.428372 0.264306 -0.101099 -0.138816 0.110415
Discharged 0.999988 0.707473 1.000000 0.908654 -0.016716 -0.061670 0.088569 0.527270
Deaths 0.910360 0.428372 0.908654 1.000000 -0.078623 -0.167342 0.269945 0.487082
Active Ratio -0.016183 0.264306 -0.016716 -0.078623 1.000000 -0.565894 -0.314438 -0.230557
Discharge Ratio -0.063901 -0.101099 -0.061670 -0.167342 -0.565894 1.000000 -0.604679 0.157141
Death Ratio 0.090619 -0.138816 0.088569 0.269945 -0.314438 -0.604679 1.000000 0.044055
Population 0.525865 0.110415 0.527270 0.487082 -0.230557 0.157141 0.044055 1.000000
In [9]:
Out[9]:
<AxesSubplot:>
In [10]:
02M4M6M010k20k30k40k50k02M4M6M02M4M6M050k100k150k020k40k02M4M6M050k100k150k
State/UTsAndaman and NicobarAndhra PradeshArunachal PradeshAssamBiharChandigarhChhattisgarhDadra and Nagar Haveli and Daman and DiuDelhiGoaGujaratHaryanaHimachal PradeshJammu and KashmirJharkhandKarnatakaKeralaLadakhLakshadweepMadhya PradeshMaharashtraManipurMeghalayaMizoramNagalandOdishaPuducherryPunjabRajasthanSikkimTamil NaduTelenganaTripuraUttar PradeshUttarakhandWest BengalTotal CasesActiveDischargedDeathsTotal CasesActiveDischargedDeaths
In [11]:
Out[11]:
State/UTs Total Cases Active Discharged Deaths Active Ratio Discharge Ratio Death Ratio Population
0 Maharashtra 6633612 11905 6480799 140908 0.18 97.70 2.12 124904071
1 Kerala 5129359 49152 5040528 39679 0.96 98.27 0.77 34698876
2 Karnataka 2995285 6783 2950306 38196 0.23 98.50 1.28 69599762
3 Tamil Nadu 2724731 8382 2679895 36454 0.31 98.35 1.34 83697770
4 Andhra Pradesh 2072446 2158 2055856 14432 0.10 99.20 0.70 91702478
5 Uttar Pradesh 1710373 86 1687377 22910 0.01 98.66 1.34 231502578
6 West Bengal 1614152 7820 1586882 19450 0.48 98.31 1.20 100896618
7 Delhi 1440834 290 1415448 25096 0.02 98.24 1.74 19301096
8 Odisha 1048492 2222 1037864 8406 0.21 98.99 0.80 47099270
9 Chhattisgarh 1006733 326 992814 13593 0.03 98.62 1.35 32199722
10 Rajasthan 954741 187 945599 8955 0.02 99.04 0.94 79502477
11 Gujarat 827382 291 816999 10092 0.04 98.75 1.22 70400153
12 Madhya Pradesh 793120 112 782480 10528 0.01 98.66 1.33 85002417
13 Haryana 771654 159 761441 10054 0.02 98.68 1.30 28900667
14 Bihar 726212 39 716510 9663 0.01 98.66 1.33 128500364
15 Telengana 675479 3545 667946 3988 0.52 98.88 0.59 38157311
16 Assam 616435 2720 607624 6091 0.44 98.57 0.99 35998752
17 Punjab 603190 313 586284 16593 0.05 97.20 2.75 30501026
18 Jharkhand 349216 109 343967 5140 0.03 98.50 1.47 40100376
19 Uttarakhand 344183 150 336626 7407 0.04 97.80 2.15 11700099
20 Jammu and Kashmir 336386 1724 330189 4473 0.51 98.16 1.33 14999397
21 Himachal Pradesh 226941 809 222287 3845 0.36 97.95 1.69 7503010
22 Goa 178839 275 175183 3381 0.15 97.96 1.89 1521992
23 Mizoram 134279 4117 129672 490 3.07 96.57 0.36 1308967
24 Puducherry 128860 326 126662 1872 0.25 98.29 1.45 1646050
25 Manipur 125117 673 122474 1970 0.54 97.89 1.57 3436948
26 Tripura 84784 89 83874 821 0.10 98.93 0.97 4184959
27 Meghalaya 84414 308 82635 1471 0.36 97.89 1.74 3772103
28 Chandigarh 65443 52 64571 820 0.08 98.67 1.25 1158040
29 Arunachal Pradesh 55269 37 54952 280 0.07 99.43 0.51 1711947
30 Sikkim 32211 114 31694 403 0.35 98.39 1.25 658019
31 Nagaland 32100 135 31269 696 0.42 97.41 2.17 2073074
32 Ladakh 21494 249 21032 213 1.16 97.85 0.99 290492
33 Dadra and Nagar Haveli and Daman and Diu 10683 1 10678 4 0.01 99.95 0.04 773997
34 Lakshadweep 10394 28 10315 51 0.27 99.24 0.49 66001
35 Andaman and Nicobar 7680 5 7546 129 0.07 98.26 1.68 399001
In [12]:
Out[12]:
State/UTs Total Cases Active Discharged Deaths Active Ratio Discharge Ratio Death Ratio Population
0 All India 34572523 105691 33998278 468554 0.31 98.34 1.36 1429869880
1 Maharashtra 6633612 11905 6480799 140908 0.18 97.70 2.12 124904071
2 Kerala 5129359 49152 5040528 39679 0.96 98.27 0.77 34698876
3 Karnataka 2995285 6783 2950306 38196 0.23 98.50 1.28 69599762
4 Tamil Nadu 2724731 8382 2679895 36454 0.31 98.35 1.34 83697770
5 Andhra Pradesh 2072446 2158 2055856 14432 0.10 99.20 0.70 91702478
6 Uttar Pradesh 1710373 86 1687377 22910 0.01 98.66 1.34 231502578
7 West Bengal 1614152 7820 1586882 19450 0.48 98.31 1.20 100896618
8 Delhi 1440834 290 1415448 25096 0.02 98.24 1.74 19301096
9 Odisha 1048492 2222 1037864 8406 0.21 98.99 0.80 47099270
10 Chhattisgarh 1006733 326 992814 13593 0.03 98.62 1.35 32199722
11 Rajasthan 954741 187 945599 8955 0.02 99.04 0.94 79502477
12 Gujarat 827382 291 816999 10092 0.04 98.75 1.22 70400153
13 Madhya Pradesh 793120 112 782480 10528 0.01 98.66 1.33 85002417
14 Haryana 771654 159 761441 10054 0.02 98.68 1.30 28900667
15 Bihar 726212 39 716510 9663 0.01 98.66 1.33 128500364
16 Telengana 675479 3545 667946 3988 0.52 98.88 0.59 38157311
17 Assam 616435 2720 607624 6091 0.44 98.57 0.99 35998752
18 Punjab 603190 313 586284 16593 0.05 97.20 2.75 30501026
19 Jharkhand 349216 109 343967 5140 0.03 98.50 1.47 40100376
20 Uttarakhand 344183 150 336626 7407 0.04 97.80 2.15 11700099
21 Jammu and Kashmir 336386 1724 330189 4473 0.51 98.16 1.33 14999397
22 Himachal Pradesh 226941 809 222287 3845 0.36 97.95 1.69 7503010
23 Goa 178839 275 175183 3381 0.15 97.96 1.89 1521992
24 Mizoram 134279 4117 129672 490 3.07 96.57 0.36 1308967
25 Puducherry 128860 326 126662 1872 0.25 98.29 1.45 1646050
26 Manipur 125117 673 122474 1970 0.54 97.89 1.57 3436948
27 Tripura 84784 89 83874 821 0.10 98.93 0.97 4184959
28 Meghalaya 84414 308 82635 1471 0.36 97.89 1.74 3772103
29 Chandigarh 65443 52 64571 820 0.08 98.67 1.25 1158040
30 Arunachal Pradesh 55269 37 54952 280 0.07 99.43 0.51 1711947
31 Sikkim 32211 114 31694 403 0.35 98.39 1.25 658019
32 Nagaland 32100 135 31269 696 0.42 97.41 2.17 2073074
33 Ladakh 21494 249 21032 213 1.16 97.85 0.99 290492
34 Dadra and Nagar Haveli and Daman and Diu 10683 1 10678 4 0.01 99.95 0.04 773997
35 Lakshadweep 10394 28 10315 51 0.27 99.24 0.49 66001
36 Andaman and Nicobar 7680 5 7546 129 0.07 98.26 1.68 399001
In [13]:
Out[13]:
State/UTs Total Cases Active Discharged Deaths Active Ratio Discharge Ratio Death Ratio Population (%) of Affected People
0 All India 34572523 105691 33998278 468554 0.31 98.34 1.36 1429869880 2.42
1 Maharashtra 6633612 11905 6480799 140908 0.18 97.70 2.12 124904071 5.31
2 Kerala 5129359 49152 5040528 39679 0.96 98.27 0.77 34698876 14.78
3 Karnataka 2995285 6783 2950306 38196 0.23 98.50 1.28 69599762 4.30
4 Tamil Nadu 2724731 8382 2679895 36454 0.31 98.35 1.34 83697770 3.26
5 Andhra Pradesh 2072446 2158 2055856 14432 0.10 99.20 0.70 91702478 2.26
6 Uttar Pradesh 1710373 86 1687377 22910 0.01 98.66 1.34 231502578 0.74
7 West Bengal 1614152 7820 1586882 19450 0.48 98.31 1.20 100896618 1.60
8 Delhi 1440834 290 1415448 25096 0.02 98.24 1.74 19301096 7.47
9 Odisha 1048492 2222 1037864 8406 0.21 98.99 0.80 47099270 2.23
10 Chhattisgarh 1006733 326 992814 13593 0.03 98.62 1.35 32199722 3.13
11 Rajasthan 954741 187 945599 8955 0.02 99.04 0.94 79502477 1.20
12 Gujarat 827382 291 816999 10092 0.04 98.75 1.22 70400153 1.18
13 Madhya Pradesh 793120 112 782480 10528 0.01 98.66 1.33 85002417 0.93
14 Haryana 771654 159 761441 10054 0.02 98.68 1.30 28900667 2.67
15 Bihar 726212 39 716510 9663 0.01 98.66 1.33 128500364 0.57
16 Telengana 675479 3545 667946 3988 0.52 98.88 0.59 38157311 1.77
17 Assam 616435 2720 607624 6091 0.44 98.57 0.99 35998752 1.71
18 Punjab 603190 313 586284 16593 0.05 97.20 2.75 30501026 1.98
19 Jharkhand 349216 109 343967 5140 0.03 98.50 1.47 40100376 0.87
20 Uttarakhand 344183 150 336626 7407 0.04 97.80 2.15 11700099 2.94
21 Jammu and Kashmir 336386 1724 330189 4473 0.51 98.16 1.33 14999397 2.24
22 Himachal Pradesh 226941 809 222287 3845 0.36 97.95 1.69 7503010 3.02
23 Goa 178839 275 175183 3381 0.15 97.96 1.89 1521992 11.75
24 Mizoram 134279 4117 129672 490 3.07 96.57 0.36 1308967 10.26
25 Puducherry 128860 326 126662 1872 0.25 98.29 1.45 1646050 7.83
26 Manipur 125117 673 122474 1970 0.54 97.89 1.57 3436948 3.64
27 Tripura 84784 89 83874 821 0.10 98.93 0.97 4184959 2.03
28 Meghalaya 84414 308 82635 1471 0.36 97.89 1.74 3772103 2.24
29 Chandigarh 65443 52 64571 820 0.08 98.67 1.25 1158040 5.65
30 Arunachal Pradesh 55269 37 54952 280 0.07 99.43 0.51 1711947 3.23
31 Sikkim 32211 114 31694 403 0.35 98.39 1.25 658019 4.90
32 Nagaland 32100 135 31269 696 0.42 97.41 2.17 2073074 1.55
33 Ladakh 21494 249 21032 213 1.16 97.85 0.99 290492 7.40
34 Dadra and Nagar Haveli and Daman and Diu 10683 1 10678 4 0.01 99.95 0.04 773997 1.38
35 Lakshadweep 10394 28 10315 51 0.27 99.24 0.49 66001 15.75
36 Andaman and Nicobar 7680 5 7546 129 0.07 98.26 1.68 399001 1.92
In [14]:
10.8%10.1%8.07%7.04%5.37%5.13%5.08%3.88%3.64%3.36%2.95%2.5%2.24%2.22%2.15%2.07%2.02%1.83%1.55%1.54%1.54%1.53%1.39%1.36%1.32%1.21%1.17%1.1%1.06%0.947%0.824%0.81%0.638%0.597%0.508%0.391%
LakshadweepKeralaGoaMizoramPuducherryDelhiLadakhChandigarhMaharashtraSikkimKarnatakaManipurTamil NaduArunachal PradeshChhattisgarhHimachal PradeshUttarakhandHaryanaAndhra PradeshJammu and KashmirMeghalayaOdishaTripuraPunjabAndaman and NicobarTelenganaAssamWest BengalNagalandDadra and Nagar Haveli and Daman and DiuRajasthanGujaratMadhya PradeshJharkhandUttar PradeshBihar(%) of people affected in each state with respect to the total population of the state
In [15]:
19.2%14.8%8.66%7.88%5.99%4.95%4.67%4.17%3.03%2.91%2.76%2.39%2.29%2.23%2.1%1.95%1.78%1.74%1.01%0.996%0.973%0.656%0.517%0.388%0.373%0.362%0.245%0.244%0.189%0.16%0.0932%0.0928%0.0622%0.0309%0.0301%0.0222%
MaharashtraKeralaKarnatakaTamil NaduAndhra PradeshUttar PradeshWest BengalDelhiOdishaChhattisgarhRajasthanGujaratMadhya PradeshHaryanaBiharTelenganaAssamPunjabJharkhandUttarakhandJammu and KashmirHimachal PradeshGoaMizoramPuducherryManipurTripuraMeghalayaChandigarhArunachal PradeshSikkimNagalandLadakhDadra and Nagar Haveli and Daman and DiuLakshadweepAndaman and NicobarCovid cases all over India in (%)
In [19]:
Total CasesActiveDischargedDeaths01M2M3M4M5M6M
MaharashtraKeralaKarnatakaTamil NaduAndhra PradeshUttar PradeshWest BengalDelhiOdishaChhattisgarhTop 10 affected states
In [20]:
01M2M3M4M5M6MMaharashtraKarnatakaAndhra PradeshWest BengalOdishaRajasthanMadhya PradeshBiharAssamJharkhandJammu and KashmirGoaPuducherryTripuraChandigarhSikkimLadakhLakshadweep
0.511.522.5Death RatioTotal CasesState/UTs
In [21]:
02M4M6MMaharashtraKeralaKarnatakaTamil NaduAndhra PradeshUttar PradeshWest BengalDelhiOdishaChhattisgarhRajasthanGujaratMadhya PradeshHaryanaBiharTelenganaAssamPunjabJharkhandUttarakhandJammu and KashmirHimachal PradeshGoaMizoramPuducherryManipurTripuraMeghalayaChandigarhArunachal PradeshSikkimNagalandLadakhDadra and Nagar Haveli and Daman and DiuLakshadweepAndaman and Nicobar
9797.59898.59999.5Discharge RatioTotal CasesState/UTs
In [22]:
01M2M3M4M5M6MMaharashtraKarnatakaAndhra PradeshWest BengalOdishaRajasthanMadhya PradeshBiharAssamJharkhandJammu and KashmirGoaPuducherryTripuraChandigarhSikkimLadakhLakshadweep
0.511.522.53Active RatioTotal CasesState/UTs
In [23]:
In [24]:
In [25]:
In [26]:
In [27]:
02M4M6M0510152025
State/UTsMaharashtraKeralaKarnatakaTamil NaduAndhra PradeshUttar PradeshWest BengalDelhiOdishaChhattisgarhRajasthanGujaratMadhya PradeshHaryanaBiharTelenganaAssamPunjabJharkhandUttarakhandJammu and KashmirHimachal PradeshGoaMizoramPuducherryManipurTripuraMeghalayaChandigarhArunachal PradeshSikkimNagalandLadakhDadra and Nagar Haveli and Daman and DiuLakshadweepAndaman and NicobarAverage cases per stateTotal Casescount
In [28]:
020k40k0102030
State/UTsMaharashtraKeralaKarnatakaTamil NaduAndhra PradeshUttar PradeshWest BengalDelhiOdishaChhattisgarhRajasthanGujaratMadhya PradeshHaryanaBiharTelenganaAssamPunjabJharkhandUttarakhandJammu and KashmirHimachal PradeshGoaMizoramPuducherryManipurTripuraMeghalayaChandigarhArunachal PradeshSikkimNagalandLadakhDadra and Nagar Haveli and Daman and DiuLakshadweepAndaman and NicobarAverage active cases per stateActivecount
In [29]:
510k25100k251M2510M010k20k30k40k50k
colorAndaman and NicobarAndhra PradeshArunachal PradeshAssamBiharChandigarhChhattisgarhDadra and Nagar Haveli and Daman and DiuDelhiGoaGujaratHaryanaHimachal PradeshJammu and KashmirJharkhandKarnatakaKeralaLadakhLakshadweepMadhya PradeshMaharashtraManipurMeghalayaMizoramNagalandOdishaPuducherryPunjabRajasthanSikkimTamil NaduTelenganaTripuraUttar PradeshUttarakhandWest BengalTotal CasesActive
In [35]:
510k25100k251M2510M020k40k60k
0.511.522.53Active RatioTotal CasesActive
In [ ]:
In [ ]: